

SELECT OBJECT_NAME(fk.constraint_object_id),
       OBJECT_NAME(fk.parent_object_id) TableName,
       cl.name
FROM   sys.foreign_key_columns fk
	   INNER JOIN  sys.[columns] cl
	   ON fk.parent_object_id = cl.[object_id] AND fk.parent_column_id = cl.column_id
       LEFT OUTER JOIN sys.index_columns c
            ON  (fk.parent_object_id = c.[object_id]  AND fk.parent_column_id = c.column_id ) 
WHERE  c.[object_id] IS NULL
ORDER BY TableName, fk.constraint_column_id 

